RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Frm6.zip

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

Most recent in Oracle DB

List the most recently added rows based on a date column.

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...